from openpyxl import Workbook,load_workbook

wb = load_workbook(
                   '部门信息表.xlsx')
sheet = wb.worksheets[0]
iter = sheet.iter_rows(min_row=2,values_only=True)
for row in iter:
    # print(type(row),row)
    name,loc = row
    print(name,loc)

wb.close()